Need some help 1

[sara403]

I need your help to see how we can do it in SDKWe will add a new miscellaneous charge item called “VIP discount”
Create a user defined field “VIPdiscnt” in Customer file to define what customer get what discount
When user select “VIP discount” miscellaneous charge, we will read from the corresponding VIPdiscnt field of the customer, multiply by the subtotal of the entire order amount, insert this value to this VIP discount miscellaneous charge instead of for user to calculate
Please find out from the existing SDK on how to modify OE screen and apply this customization

 

[sara403]

Hi tuba2007 & ettienne

As per your guidance I almost finished my work. But still i need to export the selected line items from so to excel which can be recognized purchase order format of Accpac 5.4.

can i make use of the AccPac Export & Import Functions

pls give me the guidance


thanks

saravanan

 

[Jay Converse]

Yes, you can make use of them. Export an existing Purchase Order and look at the format.

 

[sara403]

Hi tuba2007,

Thanks for your reply. As per your guidance i exported the selected line items with other Po related information in the accpac recognised excel format say a.xls(i took the format by exporting the existing PO in excel format say b.xls)

But while importing the excel file it is showing an error
as "Table Purchase order does not exist". But while we import that exported existing PO it is running correctly.

I compare both the generated files 'a' and 'b' which has similar fields and values, I couldn't find the difference.

what will be the logic which is lacking?

Please help me...

Thanks

Saravanan.T

 

[ettienne]

Look at the named ranges in the Excel files, as well as the worksheet names.

 

[sara403]

Hi

Can i export the created excel file that is same to purchase order imported. please help me

Thanks

Saravanan

 

[Jay Converse]

Yes, you can.

At this point, I think you need to find someone who understands how computers work, and speaks English well.

 

[sara403]

Hi tuba2007,

Thanks for your valuable advice

I want to know which ocx file, consists of Company id and Password.

Thanks

saravanan.T

 

[ettienne]

There is no OCX for that, you need to create your own login screen.

 

[sara403]

Hi

What is Project accounting module?

Which view id is used in AAs 5.4 for retrieving bill to address, ship to address and tax in purchase order entry.

Thanks

Saravanan

 

[Jay Converse]

What is the Project Account module? Read the user documentation in ..\DOCS\PM54AENG.

For the view ID's, record a macro while you're entering a purchase order, all the views you need will be exposed.

 

[sara403]

Hi,

I have an excel sheet consists of all the data related to purchase Order in the same format as a PO exported to excel sheet. while i import the excel sheet i am getting an error "Purcahse Order Date is Invalid"

How to overcome this error

Please help me

Thanks

Saravanan

 

[Jay Converse]

Fix the purchase order date, it's invalid.

 

[sara403]

Hi

I have an excel sheet say workbook A.xls consists of all the data related to purchase Order in the same format as a PO exported to excel sheet say B.xls . while i import the excel sheet i am getting an error "Purcahse Order Date is Invalid"

i had checked the validation of the "PO date" field in both the (A.xls & B.xls)excel sheet, both has same date format. though the error message is saying "Invalid PO date", the PO is generated, i want to avoid this error message either by correcting the field validation or suppressing the error message.

give me an idea for the above said problem

i have another question: How can i add the new exe in to the sage accpac desktop in accpac 5.4. ?

Thanks

saravanan.T

 

[Jay Converse]

1. Remove the column from the spreadsheet.
2. Object/New/Program.

 

[sara403]

Hi tuba2007,

as per ur guidance i had removed the column name "Date". which leads to another error.

before doing this i had several attempts, like file comparision, saved the xls file in different formats (95,2000,2003 excel workbooks)...etc, all leads the same error.

at last i found one door opens i.e. the file (say a.xls) which i exported from "PO" in excel format, if i use this file and reload this with my data, then i could able to import the modified "A.XLS" with my data.

if i save "A.XLS" as a excel template, and if i could open the excel workbook with the "A" template then i could successfully execute the import process in "PO"

the problem is How to Open a excel work book with desired template in VB?

am i in right path, pls help me


Thanks

Saravanan

 

[ettienne]

So you are trying to automate the import process of a PO from an Excel spreadsheet?
If so then look at generating PO's using VBA instead of importing spreadsheets, you will live longer and happier.
Step 1 is to record a macro while you enter a PO.
Step 2 is modify the generated VBA code and use it to create your PO's.

 

[sara403]

Hi

Thanks for your reply, I had another question

After login, How to find user ID and Company id.

Please help me

I want to give the below macro line instead of hot
coding.

session.open "ADMIN","ADMIN","SAMINC",DATE,0

Thanks

saravanan

 

[Jay Converse]

That question doesn't make sense. After you login, you already know what the user and company are.

 

[sara403]

Hi

If i want to execute a macro which may need company id and user Id and password.

First of all how to programmatically capture this values and pass to a macro.

(instead of hard coding with the BELOW values directly )

session.open "ADMIN","ADMIN","SAMINC",DATE,0


i need make use of the captured value to fullfill the process

session.open user_name,password,company_id,Date,0....

These information is required to excute the macro.

Please help me

Thanks

sarvanan

 

[Jay Converse]

If you're using VB, use a batch file or scheduled job, add command line parameters, and parse them from the "Command" string. If you're using VBA, you have to hardcode them.