Payments made by Accounts can be uploaded via a CSV file.
Go to Settings -> ERP Configuration -> Upload Data and select "Payment" from the pull down menu.
Load your payments file in the format specified below.
Payments are displayed on the app in the Account Dashboard
under Menu -> Debts
Sales Rep can drill down into invoices relevant to the payment if Order Statuses were uploaded for this order number. To upload Order Statuses see "How to Upload Order Statuses".
The CSV file format is as follows (all fields mandatory except for comment):
| FieldName | Description | |
| ExternalObjectID | Payment ID number (assigned by distributor) | |
| Prop_ExternalID1_Store | Account ERP code | |
| Prop_Currency | Currency of the payment (Use Currency letter codes USD, GBP, AUD, JPY, etc...) | |
| Prop_Ref | Invoice number that the payment refers to. Can be text and/or numbers | |
| Prop_Comment | Comment for the payment | |
| Prop_PaidSum | The paid sum of the debt | |
| Prop_DebtSum | The sum of the debt | |
| Prop_Date | Date (dd/MM/yyyy) |
2 comments
The information in Prop_Currency field, what kind of format should be?
EUR or €, USD or $
Thanks
The information should be in the format indicated under Settings -> Pricing Policy -> Edit one of the pricing policies and see the pull down menu of currency codes:
USD, GBP, AUD, etc. ..
Please sign in to leave a comment.