Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[Meenakshi Singh]

Hi,

Has anyone implemented 852 in their NAV database using Lanham EDI? We are looking to bring in this inventory information from our 3PL, which will be in EDI format to get it into NAV and make it user-friendly for our customer service and logistics department to be able to read/export/filter the information as needed.

Any guidance is apprciated.
Thanks,
 Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
——————————

[Lewis Rosenberg]

We have one customer sending EDI852s with Lanham’s EDI.  Lanham/Absolute Value has an “add-on” service where they can retrieve the EDI 852 data you receive (via ftp) and they provide a reporting system.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
————————————————————————
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————

NAVUG/BCUG Summit (navugsummit.com)
Orlando, FL – October 15-18, 2019
——————————
——————————————-

[Meenakshi Singh]

Hi Lewis, 🙂

This sounds interesting but my preference would be to pull the data into NAV directly. 

Thanks,
~Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
——————————
——————————————-

[Lewis Rosenberg]

Hello Meenakshi, that is also what I hoped for, but without a set of customized tables, I don’t think there’;s much you can do with the data in NAV.  Our EDI map is also a generic document map, meaning that the data only sits within the Lanham EDI tables.   Nothing is mapped to NAV tables.

FYI, I also found that the inbound EDI 852 files can be very large (If your partner is a large retailer with lots of stores), so processing the file can take a while.  It is best to automate the process or run the EDI conversion from the server or a workstation with LOTS of memory.

Here is a link to the Absolute Value solution (Absolute Value is a Lanham company):  https://www.absolutevalue-us.com/solution/pos-data-analytics.html

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare
Chalfont PA
————————————————————————
BCUG/NAVUG All-Star
BCUG/NAVUG Board of Advisors, Chairperson
BCUG/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————

NAVUG/BCUG Summit (navugsummit.com)
Orlando, FL – October 15-18, 2019
——————————
——————————————-

[Meenakshi Singh]

Hi Lewis,

I agree with the data concerns. I too was thinking about it and how it can enlarge our database size immensely. Ok, I will look more into the Lanham solution.

Thanks,
Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
NAVUG Programming Committee
——————————
——————————————-

[Valerie Ingersoll]

Hi Meenakshi,

We have the 852 set up for one of our clients as a generic document meaning we can bring the information into NAV but it’s not integrated with any NAV tables.  Let me know if you need any more information.

Thank you,
Valerie

——————————
Valerie Ingersoll
Senior Development Consultant
Innovia Consulting
Waupaca WI
——————————
——————————————-

[Meenakshi Singh]

Hi Valerie,

This solution interests me. Would you be able to share more details?

Thanks,
 Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
——————————
——————————————-

[Valerie Ingersoll]

Hi Meenakshi,

Lewis is correct about the 852 being a Lanham Absolute Value solution.  I had a client request this but decided not to move forward with it at this time.  I am not familiar with the solution but received the attached document which appears to be a little different than the one Lewis sent.  If you decide to move forward with this, I can get additional information from Lanham on this solution.

Thank you,
Valerie?

——————————
Valerie Ingersoll
Senior Development Consultant
Innovia Consulting
Waupaca WI
——————————
——————————————-

[Meenakshi Singh]

Thanks Valerie,

I appreciate your assistance with this. I will update which way we decide to go and reach out if more information is needed. We are an end user, can we reach out to Lanham directly regarding this?

Meenakshi

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
NAVUG Programming Committee
——————————
——————————————-

[Valerie Ingersoll]

?Hi Meenakshi,

Lanham usually wants end users to contact the NAV partner and then the NAV partner contacts Lanham if needed.  Let me know if you need more information.

Thank you,
Valerie

——————————
Valerie Ingersoll
Senior Development Consultant
Innovia Consulting
Waupaca WI
——————————
——————————————-

[Meenakshi Singh]

Understood. Thanks, Valerie!

——————————
Meenakshi Singh
Senior Manager, Business Applications
Home Market Foods, Inc.
Norwood MA
NAVUG Programming Committee
——————————
——————————————-

[Ronald McVicar]

We use Lanham and obtain various external info:
for Broker Sales we pull in outside sales (so an outside sales Order so we can see how well distributors / brokers are doing against sales orders that originally are generated from inbound Purchase Orders).
for certain customers we have a modified 846 for a customized inventory status report: quantity on hand, quantity on order, quantity to ship, quantity on production order, oldest lot date, etc.
for 3PL a customized 846 inbound for confirmation of transfer receipt; and 945 (Shipping Advice) and 946 (Delivery).  Many of these documents can be customized.
I thought the 852 was more for a organization who had outside pos (point of sales transactions)?

——————————
Ronald McVicar, IT Software Mgr
NSP (Quality Meats)
nspproteins.com
——————————
——————————————-

[Lewis Rosenberg]

Giving an old thread a little kick.

I’m interested to learn what solutions are being used to consume and analyze EDI852 POS data.

——————————
Lewis Rosenberg
IT Manager
Mars Fishcare/Mars Horsecare
Chalfont PA
http://www.apifishcare.com
————————————————————————
D365UG-BC/NAVUG All-Star
D365UG-BC/NAVUG Former Board of Advisors, Chairperson
D365UG-BC/NAVUG Programming Committee

Twitter: @RosenbergL
LinkedIn: https://www.linkedin.com/in/rosenbergl
————————————————————————
——————————
——————————————-