Payment Schedule - Sage 300 Update
In the Contracts feature, the Payment Schedule screen has an option to "Regenerate Payment Schedule".
This function runs a SQL update to overwrite the AROBS data table in Sage 300, with the instalment due dates and amounts
This routine matches based on:
|
IDCUST
|
String*12
|
Customer Number
|
|
IDINVC
|
String*22
|
Document Number
|
|
CNTPAYM
|
BCD*3.0
|
Payment Number
|
And updates:
|
AMTDUEHC
|
BCD*10.3
|
Original Amount (Func.)
|
|
DATEDUE
|
Date
|
Due Date
|
|
AMTPYMRMTC
|
BCD*10.3
|
Remaining Amount
|
Scheduled Process (hourly):
Implement above function based on an hourly schedule to run this routine for all new invoices created.
On success, write success notification to Payment Schedules table in byondpro.
(this is required in event update connection failed or customer does not auto-post invoices)
Prerequisite: Cemetery System Setup > Configuration: SageERPIntegrated = Y
Conditions:
Order header document type = INVOICE
Number of instalments > 1; (Invoice Header > Terms > Number of Payment of Schedules > 1)
Payment Schedule ERP Update: null
Notes to update:
By automating this routine we remove the human error factor in updating payment schedules for contracts.
We facilitate the new Deposit Required > Payment Schedule update feature
We prepare for further enhancements to the Payment Schedule features.
