Archives

 

I chose Integration Manager for the Subject Area, but I'm really using Table Import.  But I think my issue is more table structure.

I'm trying to import two GP IV Transaction tables (IV10000 and IV10001).  The one that is rejecting 100% of the records is the IV10000 (header).  It has almost all constants that I copied from a record that I manually entered.

I'm not seeing how these two tables are linked.  IV10001 has a sequence number, but I don't see that in IV10000.  The TRX QTY Total is also a funny little field, but I don't think it is part of my problem.

I'm not very good with the backside of Inventory, so any help would be tremendously appreciated.

 

 

We have many vendors that we have been processing/creating manual payments in GP Payable module.

We are switching over to pay these vendors through the check creation process.

GP is acting unexpectantly - when we create our first actual check in GP - the remittance data coming across includes all the manual payment remittance details even from historical years - very weird.

The actual check is correct - but it includes remittance data from all the prior manual payments processed (no checks printed) in GP. 

Seems crazy to me.

Anybody have any insight? Is there a payable table that has a column that flags remittance? Is the system looking to a table and attaching all remittance data? 

Hello our resident GP expert has left the company.   I understand that we should be running check links on a regular basis.  Can you tell me how often this should be run and is there simple instruction on how it should be run?    

Hello,

 

I’m reaching out to help resolve an issue we’re experiencing with when trying to add lot tracking to an existing item. The below steps were followed:

 

Steps to Enable Lot Tracking for an Existing Item:

  1. Verify and Remove Inventory:
    • Go to Inventory > Transactions > Transaction Entry.
    • Remove all on-hand quantities via an inventory adjustment (decrease).
    • Make sure this is done across all sites/locations.
  2. Close Transactions:
    • Ensure there are no open sales orders, purchase orders, or other transactions involving the item.
    • Run the Inventory Reconcile Utility (optional but recommended) to ensure data integrity.
  3. Change Item Tracking Options:
    • Go to Inventory > Cards > Item.
    • Select the item, then click the Options button.
    • Set the Tracking Option to “Lot Number” and save the changes.
  4. Re-add Inventory (if needed):
    • Use an inventory adjustment to re-enter the item with lot numbers.

 

The part in question, 001-009070-1, does currently show quantities as zero:

 

 

But when the item card is accessed, the options screen has the tracking option grayed out:

 

 

Any guidance would be greatly appreciated.

Table Definition Quick Links
All Tables
SOP Tables
RM Tables
GL Tables
POP Tables
HR Tables
PM Tables
UPR Tables
IV Tables
Olympic Tables
3