Location Transfers and Misc Adjustments

8-1-8

New to version 7-5 digits batch numbers.-Will be able to query the batch file easily. U8RECIVF4 Prompt to list batches that have info in them.

Batch numbers are now 5 digits

The info in all batches are in

U8RECIV

If after pressing ENTER after entering a batch number you get the “SETUP USER DEFINITION” window, BEWARE…….

If you get this window, . . . .

BEWARE!!!

If no invoice number is entered, the system will show transfer invoice number as 0000000.

If no invoice number is entered, the system will show transfer invoice number as 0000000.

Set Up Steps for Inventory Transfer Area

Set Up Steps for Inventory Transfer Area

• Setup the Adjustment Invoice Area 8-6-11

• Assign User to Adjustment Invoice Area 8-6-10

• If needed – Setup laser Invoice printers 8-6-12

The Reverse sign on Qty Y/N was created for employees that are use to running CI.

Employees that use CI will like the Y/N flag.

F18 (SHIFT – F6) from the CI screen is a shortcut to the Location Transfer and Misc Adjustments option.

- Trans Types can be customer created in the inventory file setup menu option 5. (8-6-5)- When creating a transfer, don’t use trans types IR, P, SA, S, AB, AT, IB, or PI because these are hard-coded in the system and may cause issues.

When creating a transfer, don’t use trans types IR,

P, SA, S, AB, AT, IB, or PI because these are hard-coded in the system and

may cause issues.

Depending on how the Reverse sign on Qty flag is set in the inventory constant file reflects how to enter the qty being transferred.

Inner-company Transfers

If the item number is used in both locations of the transfer, enter the “FROM” and “TO” location info.

If the item number is used in both locations of the

transfer, enter the “FROM” and “TO” location info.

If the item number is used only in the “FROM” location of the transfer, enter the “FROM” location info only.

If the item number is used only in the “FROM”

location of the transfer, enter the “FROM” location

info only.

Enter the item number that the “TO” location uses and the location number in the “FROM” location field.

Enter the item number that the “TO” location uses and the location number in the

“FROM” location field.

Total adjustment dollar amount must be $0.00 for the system to allow the transfer to be entered.Total adjustment dollar

amount must be $0.00 for the system to allow the transfer to be entered.

Internal Use Transfers

Creating a “trans type” just for internal use is a good way to identify these transfers from regular transfers.

When entering the tax amount for the transfer either manually calculate the $ or…….

Enter your sales tax item, total extended $ amount in the “QUANTITY” field, and verify the tax rate in the “UNIT COST” field.

What ever the total adj $ amount says, enter the opposite amount in the extended amount field, what ever the expense G/L is, and the location in the “FROM LOC” field.

Total adjustment dollar amount must be $0.00 for the system to allow the transfer to be entered.

Transfer Invoice

Transfer Edit report

Adjustments to InventoryAdjustments to InventoryPhysical Inventory AdjustmentsPhysical Inventory Adjustments

8-1-9

Before entering physical Before entering physical inventory adjustments . . .inventory adjustments . . .

Inventory End of Month check listInventory End of Month check list

Entered Merged Entered Merged

Sales X XReceivers X X XTransfers X X XInventory Blends X X X

V6.5 V7

- Can enter either EOM date or any other date.- Current Inventory quantity will show correct counts.

• Can enter either EOM date or any other date.

• Current Inventory quantity will show correct counts.

Enter the quantity of your physical count.

If the actual inventory quantity doesn’t match the current balance qty, an adjustments will post to the inventory. Either positive . . . . .

Press ENTER to proceed to the merge screen or press F3 to exit.

Inventory BlendsInventory Blends

Before creating a blend.

• Need to have an item number for the blend.

• Need to know what ingredients make up the blend.

• Need to know how each ingredient is inventoried.

- some items may be in lbs, tons, bags

• Decide if the blend needs to be an AR Blend or an Inventory Blend.

What’s the difference between an AR Blend and an Inventory Blend?

The difference is thisThe difference is thisAR BLEND

• When you have to count the ingredients item and not the blended items at inventory.

• When a sale in Counter Invoicing is invoiced, an “AB” adjustment will post to the blended item number which will offset the sale and reduce the inventory to the ingred item numbers

• The Blend Item Number needs to be an Item Code 9

The difference is thisThe difference is thisInventory Blend

• When you have to count the blended item and the ingredients at inventory time.

• When a sale in Counter Invoicing is invoiced, no “AB” adjustment will post to the blended item number which means that there will not be no offset entry to the sale and will not reduce the inventory to the ingred item numbers

• The Blended Item Number is not an Item Code 9

Inventory Blend Setup (8-6-3)

Formulation basis qty should be simple to remember if the blend needs to be manually adjusted50 lbs, 2000 lbs, 1 ton, 1 lbs, 1 bag.

The total quantity does not have to equal Formulation Basis Quantity.

The total quantity does not have to equal Formulation Basis Quantity.

AR BlendsAR Blends

Inventory Blend in CI

The adjustments for the blend shows in inventory as ‘AB’ adjustments.

Inventory Blends

8-1-10

Enter how much finished inventory that you are going to make and the location that has the ingredients and that it will be blended at.

Quantities and item numbers can be changes, removed, and added before finishing the blend adjustment.

The adjustments for the blend shows in inventory as ‘IB’ adjustments.

Inventory Reports

Summary Inventory Report in Item Sequence

This is the only Inventory report that is known of that can be run for negative quantities.

Only report in Inventory that allows you to run for negative quantity

Report U8INR1

Summary Inventory Report in G/L Number Sequence

This report can be used to gather total quantities and inventory values by G/L number for entry in the inventory in the general ledger.

Report U8INR2

Physical Inventory Report

Setup for “COUNT SHEETS”

Report U8INR3

Inventory Turns Report

For this report to calculate sales correctly, transactions types “AT” and “AB” need to show in the SALES column in the inventory inquiry screen.

For this report to calculate sales correctly, transaction types “AT” and “AB” need to show in the SALES column in the

inventory inquiry screen.

Report U8INR4

Standard Blends Information

Report U8BLR0

Adjustment Activity Report

Report U8INR7

Booked Inventory In G/L Sequence

Report U8INR8