x Want to participate? Join the group to interact

  • VI job for PO receipt of goods - T Record Invalid or Write Failed

    I've been working on a VI Import job for PO receipt of goods, serialized items. I think I am close, but I am running into this error: T Record Invalid or Write Failed. I've scoured the net, Sage City, Knowledgebase for a solution but no luck. Does anyone…

  • Can we use VI to place/drop a standard PO that pulls balance from a master PO?

    Hi, We have a lot of master PO's that suppliers ship partials in multiple shipments. Hence we assign a letter to a standard PO for each shipments using the same master PO #. The standard PO draws balance from the master PO (Master/Repeat PO). We are…

  • Sage 100 2018 Customizer question PO Receipt of Goods Date UDF to post thru to IM Cost file

    Sage 100 2018 Customizer question All Inventory items are FIFO Valuation Client wants a Date UDF added to the PO Receipt of Good Lines I added the Date UDF to the PO Receipt of Good grid I need to know the steps on how to get this Date UDF to post thru…

  • Auto Generate from Sales Order Comment Lines

    Is there a way to customize the field "Add Sales Order Customer Detail as a Comment Line" field? Right now it inputs the SO #, Customer #, Name, QTY, and Customer PO#. I only want the SO # and the QTY to be included. Is there anyway of doing this?

  • Approval work flow

    Does Sage 100 have the functionality to incorporate invoice and PO approval work flow without 3rd party software or add-in?

  • Updating Batches via BOI

    Hello all! I'm working on a script to auto approve batches but I am running into some issues. I looked through the BOI course and there is an example in there that updates the SalesOrder so I adapted my code from that. I'm not sure if I'm setting it…

  • How to use the same UDFs in PO ROG and IM Transaction Entry

    I have nearly 30 UDFs in PO Receipt of Goods Detail file and linked to posting/update files, work files and history files. These are working great. Staff wants these same UDFs to appear in IM Transaction Entry for Receipts for those items without a…

  • PO Options - Days to Retain Completed PO's

    Hi, I was trying to write a crystal report, where it would show all PO's open or closed, and allow the user to enter a PO date range and item number and then get detail list of all PO's open or closed for that item that included qty and dollars. it…

  • Change Company Logo on Invoice and PO forms

    I’m new to Sage 100. We’re running V 4.50.7.0. I am trying to find where I can change the logo on the invoices and PO’s. I’ve searched through Sage in “Setup”, “Paperless Office”, “AR” & “PO” and can’t find the forms anywhere. Can someone point this newby…

  • *CUSTOM* Purchase History Report

    I need to design a * custom * version of the "Purchase History Report" that displays the same information included in the standard report, but with only the YEAR TO DATE totals...and...all column (field) headings/detail need to be on ONE line for export…

  • RE: How to Add UDF to PO Detail Table from PO Header Table

    Thank you very much. It works. However, how to get value from different module? For example, I want to get value from PO header to add to open sales order table. Also, what are all abbreviation of different type of tables, such as header table, wrk…

  • How to Add UDF to PO Detail Table from PO Header Table

    I created a UDF, Estimated Delivery Date, in PO Header. Now I have trouble to add this UDF to PO Detail table. Anyone can help me? User-Defined Field and Table Maintenance-->PO Purchase Order Detail-->Right click-->Edit Fields-->Green '+' on the right…

  • Using Master Orders in PO

    We use Master Orders frequently to place large orders with our vendors and then send releases once a month based on an Access job which calculates our upcoming needs from MRP. However, the balance on a Master Order doesn't show up anywhere - we have custom…

*Community Hub is the new name for Sage City