Add /TAX item to Invoice

Posted By Sage-Integrator over 8 years ago

Hello, I have a customer who wants to have the Tax appear as the line item /TAX on an invoice.

Here is what I'm inserting after the items get added:

retVal = oSOInvoice.oLines.nAddLine()
retVal = oSOInvoice.oLines.nSetValue("ItemCode$", "/TAX")

retVal = oSOInvoice.oLines.nSetValue("ItemType$", "5")
retVal = oSOInvoice.oLines.nSetValue("ItemCodeDesc$", "")
retVal = oSOInvoice.oLines.nSetValue("SalesAcctKey$", "")
retVal = oSOInvoice.oLines.nSetValue("Quantity", 1)
retVal = oSOInvoice.oLines.nSetValue("Price", 1.65)
retVal = oSOInvoice.oLines.nSetValue("ExtensionAmt$", 1.65)

retVal = oSOInvoice.oLines.nSetValue("Cost", 0)

retVal = oSOInvoice.oLines.nSetValue("WarehouseCode$", "")
retVal = oSOInvoice.oLines.nSetValue("UnitOfMeasure$", "EACH")

retVal = oSOInvoice.oLines.nSetValue("TaxClass$", "NT")

retVal = oSOInvoice.oLines.nSetValue("DropShip$", "N")

retVal = oSOInvoice.oLines.nSetValue("QuantityOrdered", 1)
retVal = oSOInvoice.oLines.nSetValue("QuantityShipped", 1)
retVal = oSOInvoice.oLines.nSetValue("UnitPrice", 1.65)

retVal = oSOInvoice.oLines.nSetValue("Discount$", "N")

retVal = oSOInvoice.oLines.nWrite()

Some the stuff there is a swing in the dark, so it could be wildly inaccurate.

Any ideas as to why this line item won't show up on the invoice?

0 BadgerJerry over 8 years ago

How are you running this script? For one, you're setting the Sales Account to "".
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage-Integrator over 8 years ago in reply to BadgerJerry

Not 100% on how it's being executed, but our integration to Sage executes the VBscript files.

The thing is, the invoice is getting created just fine, except for the /TAX item. Everything else shows up, the other line items show up, customer, payment...just not this /TAX.

I'm not setting the Sales Account on the other items either but they show up.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 jepritch over 8 years ago in reply to Sage-Integrator

The SalesAcctKey is a required field for a miscellaneous item or charge. You can check the value of oSOInvoice.oLines.sLastErrorMsg, but you'll probably see a message similar to "Sales Account is required". (oops, as BadgerJerry stated)

Elliott
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Sage-Integrator over 8 years ago in reply to jepritch

I see. Any idea where I would find this SalesAcctKey value?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 BadgerJerry over 8 years ago in reply to Sage-Integrator

If the /TAX item already has a Sales Account assigned to it, you can remove the line from your code.

Also, ExtensionAmt is numeric. You should remove the $ in the SetValue for it. And, you should not set a Warehouse code for a Misc Item.

jepritch 's suggestion to check LastErrorMsg should help you clean up the rest of this code.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

Add /TAX item to Invoice

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING