3.3.5.1 Create Inventory Ordering Module

akrem
akrem
edited March 2023 in Academy Discussions

Hello,

I am receiving an error for my begginging inventory it does not make sense I used the formula builder, if anyone can help.

3.3.5.1 Create Inventory Ordering Module Question.docx

1)

Error:

IF 'SYS01 Time Settings By Week'.NOT 'SYS01 Time Settings By Week'.First week of Timescale?THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory ) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory 

The formula for 'INV01 Inventory Ordering'.Beginning Inventory is invalid:

Beginning Inventory = IF 'SYS01 Time Settings By Week'.NOT 'SYS01 Time Settings By Week'.First week of Timescale?THEN PREVIOUS('INV01 Inventory Ordering'.Ending Inventory ) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

2)

Also please confirm Shipping method is correct:

'SYS07 Distribution Center Details'.Default Shipping[LOOKUP: 'SYS08 SKU Details'.Code]

OK

Answers

  • HimanshuRaj
    HimanshuRaj

    Hi @akrem

    I've refined your formula below.

    IF NOT 'SYS01 Time Settings By Week'.'First week of Timescale?' THEN PREVIOUS(Ending Inventory ) ELSE 'DAT01 Beginning Inventory'.Beginning Inventory

    Cheers!!

  • akrem
    akrem

    Thank you

  • Powell69
    Powell69

    Inventory management software is usually part of a larger enterprise resource planning (ERP) system. If done well, that ERP unifies inventory, accounting, point-of-sale, and supply chain management on one cohesive and efficient platform.

Categories