Page 2 of 2 < 1 2
Topic Options
#16111 - 02/24/09 09:00 PM Re: Actual Cost [Re: SusanTennier]
Bruce Gardner Offline
Adagio Wizard

Registered: 06/15/04
Posts: 3613
Loc: Toronto ON, Canada
Hello Susan:

Actually you can reduce the Actual Cost without reducing the Quantity.

Look at the ICIADJ.xls file in the \Softrak\ICWIN\SAMDATA folder. To reduce just the cost, you would enter 0 for the "Stock Qty" column and a negative figure for the "Ext Cost" column. This results in a transaction where "Type" = "Cost decrease".

As suggested earlier, I would test this in Sample data first.
_________________________
Bruce Gardner
ARX Business Solutions Inc.

Top
#16112 - 02/24/09 09:09 PM Re: Actual Cost [Re: Bruce Gardner]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
Great to hear this! Thanks. I will try it.
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
#16113 - 02/24/09 10:31 PM Re: Actual Cost [Re: SusanTennier]
SusanTennier Offline
Adagio Maestro

Registered: 02/22/08
Posts: 1247
Loc: Ontario, Canada
It worked like a charm. It was weird that it forced me to provide a location when there were no quantities involved, but it had no bearing on the end result. This import saved me from entering over 200 adjustments manually. Thanks again!
_________________________
Susan Tennier
TDL Canada
Trenton, Ontario

Top
Page 2 of 2 < 1 2


Moderator:  Christa_Meissner 
Who's Online
0 registered (), 45 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1865 Members
5 Forums
14467 Topics
70660 Posts

Max Online: 432 @ 01/20/25 10:17 PM
April
Su M Tu W Th F Sa
1 2 3 4 5
6 7 8 9 10 11 12
13 14 15 16 17 18 19
20 21 22 23 24 25 26
27 28 29 30