Sage 100

Welcome to the Sage 100 Support Group on Community Hub! Available 24/7, the Forums are a great place to ask and answer product questions, as well as share tips and tricks with Sage peers, partners, and pros.

AR TRANSACTION TYPES

Posted By DigiBob over 8 years ago

Hi,

I'm writing a query of my Version 4.5, I need a listing of TransactionType used in AR_TransactionPaymentHistory and what mathematical sign should be used with each in creating a report in Excel. I know about the following Transaction Types: I, P, and X.

Thanks,

Bob M.

0 BigLouie over 8 years ago

Have you by any chance looked at the file layout? You know if you go to Resources, File Layout it's listed.

10 TransactionType . . . . . . . 1 SYN Transaction Type. . . . . . . .
Notes: I=Invoice, C=Credit
Memo, D=Debit Memo,
P=Payment, A=Adjustment,
F=Finance Charge, X=PrePayment
B=Balance Forward,
E=Balance Forward Other
Charges {AR6$(37,1)}
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 DigiBob over 8 years ago in reply to BigLouie

Thanks for the Information. When I go to Resources File Layout...I get a directory on my server ...\Launcher\html. Something is obviously wrong with my setup, but I do not know how to fix it.

Regards, Bob M
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Sage 100

AR TRANSACTION TYPES

COMMUNITY

COMPANY

PARTNERS

SUPPORT & TRAINING