Order Entry: credit tax only

Sometimes a customer is charged tax when they should not have been, and you need to credit the sales tax.

This example shows you how the do a credit note in OE for the tax portion.

Open a new OE Credit/Debit Note Entry.
Set Document Type to Credit Note and enter the customer number.
Enter/select an Invoice Number to apply the credit note to.

Click the Taxes tab and then uncheck the box next to Calculate Tax.
Enter the tax amount to be credited in the Tax Amount field, leave the Tax Base as zero.
Do not click Calculate Taxes or Distribute Taxes.

Click the Credit Note tab and then click the Item/Tax button.
If you selected an OE invoice to apply the credit note to then your item details will be displayed. If you did not select an OE invoice number then you need to enter the item numbers, for this example I will assume you selected an OE invoice.
Set the Credit Type to Price Adjustment and change the Price/Adjustment amount to zero.
Enter the tax amount in the Tax Amount field and leave the Tax Base zero.
Click Save and repeat for the rest of the detail lines on the invoice, then click Close.

Click the Totals tab and verify that the Plus Excluded Tax and Credit Note Amount equals the tax amount to be credited.
Click Post.

Accounts Payable: credit tax only

Sometimes tax is entered against an AP invoice when it should not have been, and you need to credit the sales tax.

This example shows you how the do a credit note in AP for the tax portion.

Open a new AP invoice batch, enter the vendor number and set Document Type to Credit Note, you can enter an Apply-To Document if you need to.

Click the Taxes tab and change Tax Amount to Enter and Tax Base to Enter.
Enter the tax amount to be credited in the Tax Amount field, leave the Tax Base as zero.
Do not click Calculate Taxes or Distribute Taxes.

Click the Document tab and enter the Document Number (credit note) and Apply-To Document (optional).

Enter the tax amount to be credited in the Document Total field.

Click the Account/Tax button.

Enter the GL Account and leave the Amount zero.

Enter the tax amount to be credited in the Tax Amount field, leave the Tax Base zero.

Click Add/Save and Close.

Click the Totals tab and verify the Taxes and Document Total equal the tax to be credited.

Click Add and Post the batch. 

Accounts Receivable: credit tax only

Sometimes a customer is charged tax when they should not have been, and you need to credit the sales tax.

This example shows you how the do a credit note in AR for the tax portion.

Open a new AR invoice batch, enter the customer number and set Document Type to Credit Note, you can enter an Apply-To Document if you need to.

Click the Taxes tab and then uncheck the box next to Calculate Tax.
Enter the tax amount to be credited in the Tax Amount field, leave the Tax Base as zero.
Do not click Calculate Taxes or Distribute Taxes.

Click the Document tab and then click the Account/Tax button.
Enter a Revenue account, you can use the original revenue account used on the invoice.
Leave the Amount zero.
Enter the Tax Amount to be credited, this must match the Tax Amount entered on the Taxes tab.
Click Add and Close.

Click the Totals tab and you will see the Document Amount is zero, the Plus Taxes and the Document Total amount equals the tax to be credited.
Click Add and post the batch.

Crystal: making sense of the AUDTDATE and AUDTTIME fields

Each Sage 300 ERP table has an AUDTDATE and AUDTTIME field, these store the date and time a record was last modified in the database. The date and time is stored in UTC time and needs to be converted to your local time zone to make sense.

Here is an example of a Crystal Reports formula to convert to your local time zone taken from your computer's OS settings:

ShiftDateTime (pwformatdate({GLPOST.AUDTDATE})+pwformattime({GLPOST.AUDTTIME}),"STD,0" ,"" )

AP: Printing MICR checks

The AP check report can be formatted to print MICR encoded checks from AP. You need a MICR font and the MICR line needs to be placed in the correct position on the printed check.
Read more about MICR here
The MICR font is installed when you install Aatrix and this is what the characters look like:

And this is the AP check: