Default Item Location Missing on File

[prog_0927]

Progression 7.9.310: we are troubleshooting the posting issues we have had lately and found that some items on the Item Master do not have "Default Location Set". I checked Item Maintenance in Macola for Location and Item Master and do not see a field for Default Location. Additionally, although I see the items in the Macola Item Maintenance apps for Location and Master, I do not see those item_no's in the actual DB for those tables. Just unsure where to update that information to correct it? Thank you!

Jessie

 

[dgillz]

Please clarify. You do not see a field for default location? Or the default location field is blank? In both the item master (imitmidx_sql) and item location (iminvloc_sql) the default location and location respectively are the "loc" field.

I suspect all items have a default location - in fact it is impossible to add an item in Macola without keying this info in - but the corresponding item location does not exist. This too is not possible in Macola unless the data was manipulated in SQL or MS access or similar tools.

Please let me know your findings.

Macola Software Veteran and SAP Business One Consultant on Training Wheels

Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html

 

[prog_0927]

Thank you for the response, it helped tremendously. Sorry for the delay responding, I have been working through this and the root cause was referencing the item_master and item_location tables even though I was running the file validation on other tables it always does a search into the item tables.