VFP application insert into AccPac

[bobnbee]

Hi, I have written an applicaion in FoxPro (migrated over 20 years to VFP). I have been inserting records into SBT (now Accpac) tables for years without problems, but now I have problems with payment terms. The AccPac table ARPTRMXX table has a ptrules memo field with the following:
LPARAMETERS pbject

WITH pbject
AddProperty(pbject, "SC_PTMETHOD", "D")
AddProperty(pbject, "SL_DISCOUNT", .T.)
AddProperty(pbject, "SN_DISCDAYS", 4)
AddProperty(pbject, "SN_DISCMETHOD", 2)
AddProperty(pbject, "SN_DISCOUNT", 2.000)
AddProperty(pbject, "SN_MOVEDATES", 1)
AddProperty(pbject, "SN_NETDAYS", 20)
ENDWITH

What I need to know is how much of this data is important for inserting invoice and detail records into AccPac, and how do I use this?

 

[Jay Converse]

There aren't any Sage Pro people on this forum, you'd better ask this question somewhere else.

 

[BrianoNur]

BobnBee, you can go to SBT forum to ask your questions.

I do not understand you question very well, nevertheless I will try to answer it:

WITH pbject
AddProperty(pbject, "SC_PTMETHOD", "D")
AddProperty(pbject, "SL_DISCOUNT", .T.)
AddProperty(pbject, "SN_DISCDAYS", 4)
AddProperty(pbject, "SN_DISCMETHOD", 2)
AddProperty(pbject, "SN_DISCOUNT", 2.000)
AddProperty(pbject, "SN_MOVEDATES", 1)
AddProperty(pbject, "SN_NETDAYS", 20)
ENDWITH

I don't know how familiar you are with the Sage Pro programming style, this the way 7 variables are created and initiated.

i.e. sc_pmethod is a variable, where "D" is its initial value.

These initial values are taken when you are setting up a customer otherwise, values from ARCUST datafile will be taken.

If you open the Payment Terms Maintenance Form, you will see seven fields as well, one variable per each.

Please give more details about your question.

 

[bobnbee]

Well, I am modifying the application I wrote and do not have access to the Payment Terms Maintenance Form. What I have been doing is creating armastxx and artranxx records from my own data. The problem is that I have been reading the pdays and pterms from the customer record. Which is OK, other than they have some terms that are based on days from invoice date, and the armastxx record there needs to be the difference. i.e. If the invoice is created on the 8th and the discount expires on the 10th, then the pdays for that record needs to be 2.

Long story short, I just need to know how to process the memo field, or at least find the Rosetta Stone for the meanings of all the codes.