Allow adjustments to be made with the SDX Data Exchange cash receipt template for quicker processing
Sarah Dalrymple
| Company | WRS |
| Job Title / Role | Accounting |
| I need it... | 3 months |
Dear Viewpoint Suggestion Box contributor;
We at Viewpoint sincerely thank you for your contribution to Suggestion Box on how we can improve Viewpoint products. While we can’t do everything at once, we rely upon your feedback to help guide the prioritization of our product improvements, and Suggestion Box is a critical tool for us to understand and prioritize our customers’ needs.
Viewpoint reviews Suggestion Box regularly for all of our products and updates statuses, adds comments, and performs various house-keeping (including deleting) as needed to ensure that Suggestion Box is maintained as a productive environment for product enhancements requests.
© 2023 Trimble Inc. All Rights Reserved. Viewpoint®, Vista™, Spectrum®, ProContractor™, Jobpac Connect™, Viewpoint Team™, Viewpoint Analytics™, Viewpoint Field View™, Viewpoint Estimating™, Viewpoint For Projects™, Viewpoint HR Management™, Viewpoint Field Management™, Viewpoint Financial Controls™, Vista Field Service™, Spectrum Service Tech™, ViewpointOne™, ProjectSight® and Trimble Construction One™ are trademarks or registered trademarks of Trimble Inc. or its affiliates in the United States and other countries. Other names and brands may be claimed as the property of others.
Good news! This functionality already exists and was introduced in 14.27.
DE Cash Receipts Enhancements to Allow Negative Numbers
Top Suggestion Box Request!
The Cash Receipts SOAP web service has been enhanced to support the following:
Overpayments
Apply Payments to Credit Memos
Negative Transactions
Retention Invoice Payments
Multi-currency Customers are not allowed to use this service
Overpayments
The service has a new column titled ‘Overpayment_Flag’.
Y – Yes overpay allowed
N or <BLANK> - Overpayment is not allowed
Set this flag to ‘Y’ when it is desirable to overpay a specific invoice, credit memo or retention amount on an invoice. Remember that the user can set up a ‘Default’ on the Authorization ID to default this field in as well.
Apply Payments to Credit Memos
The web service logic has been enhanced so that a 'C' (credit memo) invoice type can be used to apply payment against a credit memo.
Allow Negative Numbers
User wants to enter positive and negative transaction amounts to clean up the client aging.
Typically, this means that there will be one transactional row that will be larger than the cash receipt as a whole. To offset this transactions, there will be one or many negative transactional rows.
Customers using negatives to balance must order their transactions properly so it will summarize correctly. SOAP services post transactions one at a time, meaning that if an invoice amount is greater than the header transaction amount but the overall payment balances because of negatives, the invoice with the greater amount MUST be the last otherwise an error for insufficient amounts will result. Said another way, when the amount on a transactional line is greater than the header transaction amount, the requirement is that the transactional line must be the last row in the Excel spreadsheet.
Prior transactions are remembered so that when the header fields are the same, the system will sum the invoice payment amounts correctly with the subsequent syncs.
If the header transaction amount differs however, a mismatch between current and previously created transactions error will occur.
Apply Payments to Retention Invoices
The web service logic has been enhanced so that an 'R' (retention) invoice type is only allowed on customer open items that have retention. The user will receive an error if it doesn’t. Also, if retention is zero the payment will error.
Multi-Currency Customers are Restricted from Usage
Due to the complexities of multi-currency cash receipts, the service will reject all records from a customer that is set to use multi-currency.