Login  Register

Re: Apply Payment to GL Account

Posted by Apex Technomatics on Apr 07, 2021; 5:28am
URL: http://ofbiz.116.s1.nabble.com/Re-Apply-Payment-to-GL-Account-tp4767642p4767678.html


The Payment Type GL Account Type Id is used to translate (or map) the different payment types to a specific GL Account Type Id. The GL Account Type Id is then used via the 'GL Account Type Id' defaults to translate to one side of a journal entry.




NOTE
This GL Account default is used to link to another one of the GL Account defaults.




A Payment Type is just a way to categorize transactions.



Examples of Payment Types could be as follows:




       
       
Commission Payments
       
       
       
Customer Payments
       
       
       
Vendor (or Supplier) Payments
       
       
       
Customer Refunds
       
       
       
Customer Prepayments or Deposits
       



These payment types can then be mapped to the required account type in the Chart of Account.



Examples of these type of mappings could be as follows:




       
       
Customer Payments are mapped to Account Receivable
       
       
       
Vendor (or Supplier) Payment are mapped to Account Payable
       
       
       
Customer Refunds are mapped to Customer Credits
       



How do I add a Payment Type / GL Account Type Id mapping?


There are currently 14 different Payment Type / GL Account Types mappings that come as part of the demo data with OFBiz and should cover a good variety of payment related transactions.



       
       
Select the 'Payment Type Id' from the drop down list
       
       
       
Select the 'GL Account Type Id' to map it to from the drop down list
       
       
       
Press the 'Save' button
       
       
       
The new 'Payment Type / GL Account Type' mapping is displayed in the list at the bottom of the screen
       




How do I update a Payment Type / GL Account Type Id mapping?


A Payment Type / GL Account Type mapping cannot be updated directly but needs to be removed then re-created. If you try to update an existing entry you will get an 'duplicate key' error message.



       
       
Press the 'Remove' button next to the entry that you want to update
       
       
       
The entry is removed from the list of entries displayed
       
       
       
Select the 'Payment Type Id' from the drop down list
       
       
       
Select the updated 'GL Account Type Id' to map it to from the drop down list
       
       
       
Press the 'Save' button
       
       
       
The new 'Payment Type / GL Account Type' mapping is displayed in the list at the bottom of the screen
       




How do I remove a Payment Type / GL Account Type Id mapping?



       
       
Press the 'Remove' button next to the entry that you want to delete
       
       
       
The entry is removed from the list of entries displayed
On 2021/03/30 20:04:00, <[hidden email]> wrote:
>
> In AR there is the ability to Apply Payment to GL Account.  Does anyone
> know the business reason why a payment would be applied to a GL Account?
>  Anyone know how to record a deposit on a purchase Order?
>
> Thanks,
>
> James
>