☑️Import Cash Payments in ParcVu Desktop

It is possible to import payments via a CSV file on the Post Cash screen (Ledgers Sub Menu > Post Cash). Two new options have been added to the Cash Posting Options section of the screen: "Generate Import Template" and "Import Cash Payments".

The "Generate Import Template" option generates an empty CSV file to be used as a template to insert payments that you want to import into ParcVu.

The "Import Cash Payments" option allows you to select a CSV file to import. If the selected file matches the required format, then all rows that can be imported will be displayed in the main grid on the Post Cash screen. From here, any validation problems can be resolved in the grid then the payments can be posted.

Spreadsheet columns:

Account No - ParcVu Account no - Optional but there must be a value for this OR the External Account No

External Account no - maps to the ParcVu 'Old Account' field. This value should be used to look up the account so the account no field in the grid can be populated - This field is optional and should only be used if the account no field is empty.

Code - These values are 'invoice text code' values from the INVOICE_TEXT_CODES table. You can find these codes in System Maintenance > Maintain Lookups > Invoice Text Coes, for example if it is a BACS Payment for the Rent Ledger, the Invoice Text code is RBS. These need to be looked up and if the code is incorrect the data should not be imported into the grid - Mandatory Field

Description - The description to be stored against the payment. Max length 50 - Optional (Use invoice text code description if no value)

Sales Amount - Amount to be posted to the sales ledger - needs validating against the 'Code' field as codes are ledger specific. Check the current screen validation rules. Only one amount can be entered per ledger.

Rent Amount - Amount to be posted to the rent ledger - needs validating against the 'Code' field as codes are ledger specific. Check the current screen validation rules. Only one amount can be entered per ledger.

Booking Amount - Amount to be posted to the rent ledger - needs validating against the 'Code' field as codes are ledger specific. Check the current screen validation rules. Only one amount can be entered per ledger.

Receipt - True or False, Yes or No, Y or N - Optional - Default to False

Payment Details - max length 30 - Optional