Replies posted by wzalewski

5 Replies

M
melissahInspiring
asked in Kinetic & Epicor ERP

Excel Data Only Some GL reports error out when trying to print to Excel Data Only

Can you print Stock Status or WIP/Rec to CSV? 

5
M
4 months ago
M
mgarittaKnown Participant
asked in Kinetic & Epicor ERP

BOM Categories

I can’t find anything what you are looking for.This attachment shows a Excel macro formatted actual Epicor SSRS BOM report.The SSRS is hard to read.I have another macro running after this to add costs to the right for each part (material, labour, burden, subcontract), but if the costs are not rolled up, the total cost on the BOM is incorrect.\There is nothing I found on manufactured BOM.  Please, someone direct me to one that is readily available.

1
W
5 months ago
W
wzalewskiInspiring
asked in Americas - New York City & New Jersey

Date format when printing to CSV

Sorry, but Glen’s answer is incorrect. 

6
W
1 year ago
W
wzalewskiInspiring
asked in Americas - New York City & New Jersey

Date format when printing to CSV

Thank you for noticing. I wasn't even thinking about it.However, the formula is not wrong.The .csv file coming from Epicor changes the format in the date field.At the top when macro enters formula the result is correct. Then copied down creates a wrong date because the format in the file is wrong.Please take a look at the two attached screenshots.I change the formula in the macro to accommodate the length of entry in the original cell and choose the correct Y/M/D selection.Works like a charm.Thank you.   Maybe someone can clean it for me: Sub WipPrep()    Application.ScreenUpdating = False            Call MoveWIPSum    Call DelWipColumns    Call WIPColWidths    Call WIPFormulas    Call InsertYM        Application.ScreenUpdating = True    Range("A2").Select        MsgBox "Done"    End SubSub MoveWIPSum()    Application.ScreenUpdating = False        ActiveSheet.Name = "WIP"        Range("A1").End(xlDown).End(xlDown).Select    ActiveCell.CurrentRegion.Select        Selection.Cut        Sh

6
W
1 year ago
W
wzalewskiInspiring
asked in Americas - New York City & New Jersey

Date format when printing to CSV

Hi Kevin.Thank you for noticing, which I did not even look at.The issue is completely different here, after I read that the formula is wrong.Please take a look at the second attached screenshot.At row 3798 the date changes spots in each column. Macro enters formula in row 2, below the headers and never expects the change in date at some point.Screenshot 3 shows the date formatting as it is opened in Excel.I will change the formula to account for the changes and it will be fine. Thank you for your help.Wes 

6
W
1 year ago
Terms & Conditions