Search results

Hi All, I am here with attaching a customized program for doing transfer from location to location. it will display an error when the status (ld_status) from the "From" location is different as from the "To" Location. Except if the status can be find in the generalized code...

Hi All, I am here with attaching a customized program for doing transfer from location to location. it will display an error when the status (ld_status) from the "From" location is different as from the "To" Location. Except if the status can be find in the generalized code...

Hi, When i extracting the item inventory data for a requirement, i noticed that the in_avg_date has values for year 2007, i am not sure how the system is pick up the date and also please let me know how to update the Average_Sales & Average_Issue data . Thanks in advance.

Hi I hve created a program which will deliver the CSV file for the item planning data. my item number is having 00 as prefix but when i open the csv file, i am geting the out put as below. the item numbers showing without the two zeros as per the sample below Item_Number UOM Order_Qty...

When processing invoices we have found that any variances (AP Price Variance, etc.) are automatically coded to Cost Center xxx by MFG-Pro. On the Product Line maintenance, we have stipulated the Cost centers that all variances should be coded to (this is working fine for other variance types –...

Hello, I have to deliver last year the Net Sales value by Vat Code By Ship To Country I requred as follow Ship From, Ship To Country, Sold To, Vat Code, Net Amount. I have created the below script but the each line is displaying two times output to netsales.xls. def var...

Hi, I have created a program that should out put a flat file in a folder. but while running the code i am getting the following error : Report is now running. Press Ctrl-C to cancel ** Unable to open file: /extdata/desktop/dtlive/Board/Sales_details.txt. Press space bar to continue. How...

Hi I try to dump the Alternate Unit of Measures in a file. I created the following program. but the output is not correct. For instance item number 017299 gives following output. 017299;22+03+11;Contec;OK;1;1;.001;1;10;5;6;1000;1;1;001; For this item the alternate UM DU is not available...

Hi I have created the Cim file like below and uploaded.. @@batchload glbgmt.p 4001 "B09" 80110 - "G160" - - 2009 - - 1 - 8012 12/24/08 . @@end @@batchload glbgmt.p 4001 "B09" 80110 - "G160" - - 2009 - - 2 - 8012 12/24/08 . @@end @@batchload glbgmt.p 4001 "B09" 80110 - "G160"...

Hi, For a requirement i have created a program (attached here with) and compiled, i haven't get any error while compilation, while running the program i am getting the error as below ========================================================== ** FIND FIRST/LAST failed for table pt_mstr. (565)...

Hi how do i get a list of products which are sold the last 3 years. I need pt_part pt_desc1 and pt_desc2 Thanks

Hi, mfgpro Verision: EB2 /Sp: 9/ Os:Unix / Desktop 2 For a requirement inside the program i want to know from which user id the program is running. How do i find the user using this prorgram inside the same program (login user id)? is it possible?.. Thanks for your help.

Hi All, for a requirement I had developed the code as below define var frmnbr like so_nbr . {mfdeclre.i} update frmnbr. for each so_mstr where so_nbr = frame-value no-lock: find first usr_mstr where so_site = usr_access_loc no-lock no-error. If not avail usr_mstr then...

Hi All, for a requirement I had developed the code as below define var frmnbr like so_nbr . {mfdeclre.i} update frmnbr. for each so_mstr where so_nbr = frame-value no-lock: find first usr_mstr where so_site = usr_access_loc no-lock no-error. If not avail usr_mstr then...

Hi, I have created a program which will ckeck the usr_access_loc and so_site Pls find below the codes " {mfdtitle.i "b+ "} define variable nbr like so_nbr. define variable nbr1 like so_nbr. form nbr colon 25 nbr1 label {t001.i} colon 50 with frame a width 80 side-labels no-attr-space...

Hi, I have created a program which will ckeck the usr_access_loc and so_site Pls find below the codes " {mfdtitle.i "b+ "} define variable nbr like so_nbr. define variable nbr1 like so_nbr. form nbr...

Hi All, For a program i need to know how i can find all ld_det records where ld_status does not begins "Rej" I have createdthe script like below For each ld_det where ld_domain = global_domain and ld_part = wod_part and ld_site = wo_site and ld_status <> "reject"no-lock: With this...

Hi, I have created a program for price list report, while running the report i am getting some error "like unable to find file :TMP6720.out." after pressing the Space Bar i am getting the report. I am here with attaching the codes as well as the out put. kindly help me out to resolve this...

In the Sales Order by Order Browse 7.15.4 – can this be restricted to retrieve information for only the for a particular site? In the Invoice Print we need to restrict this to being able to invoice "particular site" orders only - is it possible ? Thanks for your help.

I have created a Program , and it works fine but i am getting a all the lines are repeated again and again, there could be some bug which i couldn't found it . I am here with attaching the program as well as the out put for your reference kindly look in to it and post the Solution ASAP...