Dear Chau,
Please have a look at the "Down Payment Invoices" functionality of ?B1 which might be able to help you out in this situation.
Here is an extract from B1 Help files :
-
-
There is a business need for companies to issue and receive invoices including tax (or VAT) for down payments made or received. These invoices are then cleared with partial or final invoices. Companies record a down payment received in SAP Business One by creating a payment not based on an invoice. However, due to legal requirements in certain countries, the recording of a down payment requires an invoice or a billing document.
The procedure below explains how to create down payment invoices and how to clear them.
Prerequisites
To be able to use down payment invoices, you have made the following definitions:
· You have defined a clearing account in Administration Setup Financials G/L Account Determination Sales and Purchase tabs. If you intend to use the down payment invoice only for sales or only for purchases, make this definition on the relevant tab.
The following definitions are optional; the default values determined by the definitions are described above.
· You have defined special down-payment clearing accounts for each business partner in Business Par tners Business Partner Master Data Accounting General .
Process
Create an A/R or A/P Down Payment Invoice for a relevant business partner. If you create the down payment invoice by drawing a base document, ensure that you have defined the required down payment percentage (for more information, see A/R or A/P Down Payment Documents: General Area).
The down payment invoice does not affect inventory values or perpetual inventory. It creates a posting only in accounting. It does not change the status of the base document drawn to it.
Once the actual payment for the down payment invoice is made, create the proper payment document, based on the down payment invoice. A down payment invoice can be paid partially.
After you create the payment document, a journal entry is recorded in the down payment clearing account defined in Administration Setup Financials G/L Account Determination Sales and Purchase tabs General . The down payment request is closed.
Note
If you cancel the payment created for the down payment by choosing the option Data Cancel from within the Incoming/Outgoing Payment, the paid down payment is re opened and cannot be drawn when creating an invoice. However, if for example the payment mean used for paying the down payment was check, and you cancelled the check from within the Check Register, then, the down payment remains closed and can be drawn when creating an invoice.
End of the note.
Create a regular invoice. Before you add it, click to open the Down Payments to Draw window. Draw the required down payments from this window.
The total amount of the drawn down payments is taken from Total Down Payment in the invoice. This amount is reduced from the invoiceu2019s original total amount. The down payment total must be less than the invoice total.
Note
The down payment invoices and regular invoices can be paid in the same paymant document. The down payment documents can be easily noticed in the payment document since they carry a different document type which is: DT.
End of the note.
Result
· The total of the regular invoice created with reference to the down payment invoice equals the difference between its original total and the down payment total.
· A down payment invoice that is drawn to invoice is closed and cannot be drawn again to another invoice.
More Information
A/R Down Payment Invoice
A/P Down Payment Invoice
-
-
Regrads
Arshdeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.