How to add a filed on Sales Transaction Entry screen ?

[FaFa168]

Hi there

Can someone tell me how to add a field to the sales transaction entry screen in detail ?

I'd like to replace the unit cost field to standard cost in the detailed item section. I am using GP 8. Can someone tell me step by step how to achieve this. I am using vb modifier.

Many Many thanks

 

[winthropdc]

Are you talking about just displaying the standard cost as readonly?

Normally, you cannot change unit cost as this is updated automatically by the system when you post to the appropriate cost based on the valuation method of the item.

If you can explain more about what you are trying to do it would be helpful.

PS: It is possible to achieve this with VBA and modifier, but you will probably need to use RetrieveGlobals.dll and ADO to get access to the SQL data to read the value of Standard Cost and display it on the window.

David Musgrave [MSFT]
Senior Development Consultant
Escalation Engineer
MBS Support - Asia Pacific

Microsoft Business Solutions

http://www.microsoft.com/BusinessSolutions

Any views contained within are my personal views and
not necessarily Microsoft Business Solutions policy.
This posting is provided "AS IS" with no warranties,
and confers no rights.

 

[FaFa168]

Hi winthropdc

Thanks for your response.

I am trying to add a filed to display the standard cost for each items in sales transaction entry screen. and remoe the current cost field.

I do have programming background (including SQL), but new to GP, I don't know where to start, and how to add a field to the detailed item section of the screen, and how to associate this field to a particular column in DB, and how to call a stored procedure from that screen to fill out this new field I add.

Can you tell me how to do this.

Many thanks

 

[jazgeek]

I would assume (can't verify this exact moment) that the "unit cost" field in the sales order line detail would reflect either current cost or standard cost depending on the valuation method picked for that item ie perpetual or periodic.

Interesting thing to try out.



-----------
and they wonder why they call it Great Pains!

jaz

 

[FaFa168]

Jaz, good point, let me try that out, maybe I don't need to change anything at all.

Thanks