CIDs in Master Bill To Print Tax On Commission and Net Due Amount

Reference No: R2-12476

Version No: 06.00.06-00_P05

 Master Bill commission and Tax have been supported in MB Print and in Great Plains Export.

Prerequisites

1. Calculate Tax After MB Discount must be unchecked in Site Edit screen.

2. GL codes must be defined for Taxes, Master Bill Commission, Sales, and Tax on MB Commission.

   1. Complete the setup in Invoicing GL Code Details > MBCOMTAX.

Print

Support is provided for below CIDs in Master Bill Print in 169500UI.

Table 1.0 CID Details For Master Bill Invoice

Credit and Debit memo on Master Bill are also considered for the above CIDs.

For CIDs 01, 02, and 03

To fetch details from different rows of Tax schedule table, prefix CIDs with row number as shown in belowExample. The first digit denotes the row

Great Plains Export

1. Details of the Tax on Commission are exported separately.

2. Dist.txt

3. Tax entry will be written based on the flag ‘Calculate Tax after Commission’

   • Tax on commission entry is supported

   • Account No exported for Tax on commission should be defined for Invoicing GL Code Details > MB Comm Tax (this flag is supported)

4. Posting Register Report

   • Should reflect as per Dist.txt described above

5. Tax Amount in R2RM

   • This will use the formula, Tax on MB Invoice Total (Tax entry value in dist.txt) - Tax on Commission (Tax on commission entry value in dist.txt)

6. TDetail.txt

• Tax Amount: MB Invoice Total - MB Commission

  • Amount: Tax on MB Invoice Total (Tax entry value in dist.txt) - Tax on Commission (Tax on commission entry value in dist.txt)

Sample Workflow

1. Create Order as below

2. Create a Master Bill Invoice as below

3. Print the Master Bill Invoice

4. CIDs supported are shown below

Great Plains Export

1. Define GL Code for MB Commission Tax as required. Example below

2. Post the Invoice

3. R2 Posting Register displays Master Bill commission Tax

4. Dist.txt displays Master Bill commission Tax as below

5. R2RM.txt

6. Tdetail.txt