Search results

mmmmh... two possible approaches... if the allowance is say, a percentage of a given line in the PO, perhaps a discount list added to that line that represents a previously defined discount. In this case, the discount can even be tracked using special discount accounts to hit the GL. Another...

No way that I know of but you can use even a simple DOS command line to copy to a file to another starting after a given number of lines. Linux will have its own options. This will copy one file to another skipping first line. more +1 FILE-WITH-LABEL.csv > FILE-NO-LABEL.csv if you put that in...

In Enterprise Edition, at customer maintenance level, Credit TAB there is a fields called "Credit Agency Reference". That is the one. In fact, it makes reference in the field explanation that D&B is one of the common agencies. The field name in EE table customer table (Debtor) is...

Hi Xchristi... Where to maintain the accounts related to the OVH? First check Product Line Maintenance or, if in use, Item Site Purchasing Accounts (Overhead Applied Acct-Sub-CCtr is maintained there). Are the actual accounts inactive? You need to check GL Account Maintenance (or sub or cctr)...

Thank you Tom. You are the super expert and I am very appreciative of all the support you have given to everyone through the ages.... LuisG

Thank for the code Tom. I was trying to... 1)avoid having to call each field and 2)resolve this using a straight-forward "export xx_table" (rather than calling individual fields, replacing through functions or using variables in their place or resorting to "put" command). One other thing I...

Good day, In this case I am trying to use a straight-forward "export xx_table" command (rather than to use a put for each field) but make all dates use a specific format. I have found some work arounds but I assume there is a better way to do it. It has been a while and can't remember if...

Please remove topic. Came to conclusion that from a practical stand point, is not attainable. The expected report/output can not be achieved as per requested, at least not in a simple result due to the structure of the DB and the multiple M:1:M table relations, in the end the effort and...

Well, in theory, the only thing you need to do is adjust the VAT rate starting on a given date, move it from 19% to 16%. I can't recall if in that version you still had the VAT, GST/PST and GTM selection in the main control file (later GTM became the only tax system). But in any case, you should...

Andy, mmh... Incomplete information here for a precise diagnostic. First, assuming all steps in calculation of requirements/demand, distribution network were in place and followed a correct sequence for DRP/MRP process. Can't really get a full grasp but, consider that if those items were in...

Ravindranath, CST-ADJ is an inventory-related transaction type resulting from a change in the cost of the item, to both record the moment of change as well as reflect the resulting change in inventory valuation to the GL. Example, the item's cost was 10USD and there were 100 of them...

for the purpose of sharing... go to the entity security and add the entity to the list first. The list if I recall correctly based on Generalized Codes, so the validation is preventing it from adding. There is an entry in Entity Validation for "*" which can be used to restrict any.

I am seeing there is an error that will make your process fail in the first loop within MAINLOOP. You are trying to search pt_mstr and likely you do not have an item pt_mstr where pt_part = "Item Number". You should either first eliminate that first line (title row) or handle a for first...

this is an old post but here is some advice... use the overhead directly at the item level would be an option. To handle logistics costs separately from the rest, make sure the Product Line definition has overhead account is some "Logistics Cost Estimate/Reserve" expense account. You can add the...