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: 3654
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 (), 566 Guests and 0 Spiders online.
Key: Admin, Global Mod, Mod
Forum Stats
1867 Members
5 Forums
14567 Topics
71092 Posts

Max Online: 1148 @ 11/22/25 01:55 AM
November
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