Background
AATC will use Sales Invoices with Record Type = POS, to record sales transactions and then collect payments using a register.
...
Cash
Check
AM EX
Visa
Master Card
Discovery
Zelle
Wire
Rental
Add a related list, POS Cash Receipts, to the Sales Invoice page (with record type = POS). (done)
Payment Method
Document No.
Amount
This table can be used if the Sales Invoice cannot be posted.
If the Sales Invoice can be posted, users can just Create Customer Receipts without using this new table. If there is more than one Customer Receipt, users can clone the first Customer Receipt to create a new one.
Future Enhancements:
Replace the current Post button with a new Post. button.
Only for record type = POS
If Document Status = Open, post the Sales Invoice.
Check the total Amount from the related list, POS Receipts.
If it is different from the Remaining Amount of the Sales Invoice, error.
Create Customer Receipts. One Customer Receipt per POS Amount
Add a Post Cash Receipts button to the POS Sales Invoice to create and post Customer Receipts and apply Customer Receipts to the Sales Invoice. Done
Error if the Sales Invoice is not posted.
Error if the total payment does not equal the total Sales Invoice Amount
Add a Sales Invoice lookup field to the Customer Receipt page.
Copy Sales Invoice to Customer Receipt.
Make sure to copy the Payment Method to the Customer Receipt.
Payment Method picklist on Customer Receipts should have the same values listed above
Post Customer Receipts and apply them to the Sales InvoiceBank Account must be the Undeposted Cash Account defined on the Company Setup.
To unpost to correct cash receipt mistakes. Users must:
Unpost Customer Receipts one by one.
Delete Customer Receipts
Then correct Customer Payments on the Sales Invoice.Or unpost Sales Invoice to correct it
Then click the Post Cash Receipts button again.
The End of Date report must be based on Customer Receipts.
We may need to create a few formula fields on Customer Receipts to get data (such as Warehouse) from the Sales Invoice.