Page 1

LILAC Document Help

Reports > Inventory > Price Adjust

The purpose of this report is to edit (change) Costs or Selling Prices in the Stock Account.
An example is shown on the following pages, adjusting the Standard and Current Cost of all 4 Product Codes in the Group CABLES.

In the example Standard and Current Cost are Adjusted by 10%.
In the example the Selling Price in the Stock Account will automatically be adjusted too, as an 100% Mark Up (on the Standard Cost) is already in place in the Stock Account

Within the report, a drop down menu allows selections.

The OK button progresses to a review stage, after which a second OK will commit the changes to the Stock Account, potentially across thousands of Product Codes within the Stock Account.

Before the final commit, the Cancel button can be used to abort.

Example

Page 2
Reports > Inventory > Price Adjust

There are many options to select a range of Product Codes to Adjust the Cost or Selling Prices. In this example a Group : CABLES is selected, this Group contains four Product Codes. These Product Codes can be reviewed before committing to the adjustments.

Reports > Stock > On Hand With Prices > Convert Excel or PDF
Reports > Stock > Extended Detail -> Convert to Excel
... are two other reports to review and perhaps temporarily save Product Code cost and price data for checking or reference.

First Window - Review

Clicking OK will progress without committing the proposed changes.

In most cases Current and Standard Cost would be set to be the same.

Example Continiued

Page 3
Reports > Inventory > Price Adjust

Second Window - Commit

Review the proposed changes.

The User may use the Cancel button at this stage. There will be no impact on the Stock Account.

Clicking OK -> WILL commit the proposed changes.

In most cases Current and Standard Cost would be set to be the same.

Process Complete

Example Continued

Page 4
Reports > Inventory > Price Adjust

In the example Standard and Current Cost are now adjusted by 10%.
The Selling Price in the Stock Account has automatically adjusted too, as a 100% Mark Up is in place... based off the Standard Cost.